Description:
Created by: Bryan Hong, Online Teaching Excel Expert
Language: English
Released: 2019
Torrent Contains: 20 Files, 1 Folders
Course Source: https://www.skillshare.com/classes/SQL-Master-Database-Queries-in-Just-90-Mins/1192226128
Description
Last time you tried to get a report from your raw data, however writing SQL queries proved to be a troublesome task..
But it doesn't have to be this way!
You Will Walk Away With...
• MORE TIME!
• Master writing SQL queries in just 90 minutes!
• Understand the essence of these queries, without memorizing them!
• See how each of these queries are used with real examples!
After this class you will be able to:
• Actually SMILE when you start writing SQL queries 
• Get valuable data insights anytime you want from your raw data!
If you're like me, you use SQL on a daily basis for important tasks, text processing, calculations or even web development. Whether it's for business or personal related projects, everyone wants to be able to use these SQL queries freely and easily.
If you're ready to gain full control of SQL Queries TODAY, take the “SQL: Master Database Queries" course right now and master the following:
• All about SQL and databases
• Simple to Advanced Single Table Queries
• Joining Multiple Tables
• Writing Subqueries
Skills in this Class
• TECHNOLOGY
• WEB DEVELOPMENT
• SQL
• DATABASE
• MICROSOFT
• DATA SCIENCE
• BUSINESS INTELLIGENCE
Projects & Resources
For our class project, we will be using the exercises from our SQL Joins and Subqueries topics. Please share your queries that you have created on the following questions below:
1. Get the last name, first name, classroom id, and grades of the students
2. Get the last name, first name, classroom name, and grades of the students
3. Get the first name, last name, average of all grades of each student
4. What is the average score of Donald Duck?
5. Which class of Mickey Mouse has the highest grade? (Give the class name)
6. Get the average score for each class (show the class name and average score)
7. Get the last name, first name, Class Name and weighted grade (weight * grade) of each student
8. What is the final grade of Donald Duck?
• To compute the final grade, sum all the weight * grade of each class
• Example: (Class #1 Weight * Class #1 Grade) + (Class #2 Weight * Class #2 Grade) and so on
9. What is the final grade of all of the students? Show FirstName, LastName and the Final Grade
10. Get the Average grade of each student for the Running and Acting classes. Show FirstName, LastName, and Average Grade of the 2 classes
What we want to see is the diversity of SQL solutions as each person has their own unique way of solving the problems. With this, we can learn on different approaches from each other and give constructive feedback as well on how we can improve our SQL queries. Good luck!
(Visit Official Page to get the above file that given by the course author)
About Author
With over 10 years of IT and teaching experience, I love sharing what I know through online classes. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I will explain complex ideas to you in a easy-to-understand lessons. Feel free to reach out for any questions!
 |
-